using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VKAVERF
    {
        public DataRow Convert2KAVERF(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryKAVERF(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["KAVMANDANT"] = " ".PadRight(2 ); 
         dwReturn["KAVKANR"] = " ".PadRight(8 ); 
         dwReturn["KAVKAPOS"] = " ".PadRight(4 ); 
         dwReturn["KAVPOS"] = " ".PadRight(2 ); 
         dwReturn["KAVWERK"] = " ".PadRight(3 ); 
         dwReturn["KAVANRKR"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB"] = " ".PadRight(3 ); 
         dwReturn["KAVME"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE1"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE2"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE3"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE4"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE5"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE6"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE7"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE8"] = " ".PadRight(0 ); 
         dwReturn["KAVANRKR2"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR2"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV2"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB2"] = " ".PadRight(3 ); 
         dwReturn["KAVME2"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE21"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE22"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE23"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE24"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE25"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE26"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE27"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE28"] = " ".PadRight(0 ); 
         dwReturn["KAVANRKR3"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR3"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV3"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB3"] = " ".PadRight(3 ); 
         dwReturn["KAVME3"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE31"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE32"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE33"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE34"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE35"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE36"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE37"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE38"] = " ".PadRight(0 ); 
         dwReturn["KAVANRKR4"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR4"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV4"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB4"] = " ".PadRight(3 ); 
         dwReturn["KAVME4"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE41"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE42"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE43"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE44"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE45"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE46"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE47"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE48"] = " ".PadRight(0 ); 
         dwReturn["KAVANRKR5"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR5"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV5"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB5"] = " ".PadRight(3 ); 
         dwReturn["KAVME5"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE51"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE52"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE53"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE54"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE55"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE56"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE57"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE58"] = " ".PadRight(0 ); 
         dwReturn["KAVANRKR6"] = " ".PadRight(2 ); 
         dwReturn["KAVALFDNR6"] = " ".PadRight(6 ); 
         dwReturn["KAVAFOV6"] = " ".PadRight(3 ); 
         dwReturn["KAVAFOB6"] = " ".PadRight(3 ); 
         dwReturn["KAVME6"] = " ".PadRight(1 ); 
         dwReturn["KAVMENGE61"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE62"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE63"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE64"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE65"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE66"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE67"] = " ".PadRight(0 ); 
         dwReturn["KAVMENGE68"] = " ".PadRight(0 ); 
         dwReturn["KAVMIX"] = " ".PadRight(0 ); 
         dwReturn["KAVHK1"] = " ".PadRight(0 ); 
         dwReturn["KAVHK2"] = " ".PadRight(0 ); 
         dwReturn["KAVHK3"] = " ".PadRight(0 ); 
         dwReturn["KAVHK4"] = " ".PadRight(0 ); 
         dwReturn["KAVHK5"] = " ".PadRight(0 ); 
         dwReturn["KAVHK6"] = " ".PadRight(0 ); 
         dwReturn["KAVFE1"] = " ".PadRight(0 ); 
         dwReturn["KAVFE2"] = " ".PadRight(0 ); 
         dwReturn["KAVFE3"] = " ".PadRight(0 ); 
         dwReturn["KAVFE4"] = " ".PadRight(0 ); 
         dwReturn["KAVFE5"] = " ".PadRight(0 ); 
         dwReturn["KAVFE6"] = " ".PadRight(0 ); 
         dwReturn["KAVFE7"] = " ".PadRight(0 ); 
         dwReturn["KAVFE8"] = " ".PadRight(0 ); 
         dwReturn["KAVFE9"] = " ".PadRight(0 ); 
         dwReturn["KAVFE10"] = " ".PadRight(0 ); 
         dwReturn["KAVMKKG"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKKG6"] = " ".PadRight(0 ); 
         dwReturn["KAVMKSG"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSG6"] = " ".PadRight(0 ); 
         dwReturn["KAVMKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKROHW6"] = " ".PadRight(0 ); 
         dwReturn["KAVMKREZ"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKREZ6"] = " ".PadRight(0 ); 
         dwReturn["KAVMKZU"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKZU6"] = " ".PadRight(0 ); 
         dwReturn["KAVMKSO"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO1"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO2"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO3"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO4"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO5"] = " ".PadRight(0 ); 
         dwReturn["KAVMGKSO6"] = " ".PadRight(0 ); 
         dwReturn["KAVFFKG"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKG1"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKG2"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKG3"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKG4"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKG5"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKG"] = " ".PadRight(0 ); 
         dwReturn["KAVFFKK"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKK1"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKK2"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKK3"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKK4"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKK5"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKK"] = " ".PadRight(0 ); 
         dwReturn["KAVFFKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAVFFKV"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKV1"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKV2"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKV3"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKV4"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKV5"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKV"] = " ".PadRight(0 ); 
         dwReturn["KAVFFKKONF"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKKONF1"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKKONF2"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKKONF3"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKKONF4"] = " ".PadRight(0 ); 
         dwReturn["KAVFEKKONF5"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKKONF"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGK1"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGK2"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGK3"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGK4"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGK5"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAVLAEV"] = " ".PadRight(0 ); 
         dwReturn["KAVLAETOT1"] = " ".PadRight(0 ); 
         dwReturn["KAVLAETOT2"] = " ".PadRight(0 ); 
         dwReturn["KAVLAETOT3"] = " ".PadRight(0 ); 
         dwReturn["KAVLAETOT4"] = " ".PadRight(0 ); 
         dwReturn["KAVLAETOT5"] = " ".PadRight(0 ); 
         dwReturn["KAVLAEG"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGV"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGTOT3"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGTOT4"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGTOT5"] = " ".PadRight(0 ); 
         dwReturn["KAVWAGG"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZV"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZTOT3"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZTOT4"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZTOT5"] = " ".PadRight(0 ); 
         dwReturn["KAVMEZG"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE1"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE21"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE22"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE23"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE24"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE25"] = " ".PadRight(0 ); 
         dwReturn["KAVRESERVE3"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP1"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR1"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT11"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT12"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT13"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT14"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT15"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP2"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR2"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT21"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT22"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT23"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT24"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT25"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP3"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR3"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT31"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT32"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT33"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT34"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT35"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP4"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR4"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT41"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT42"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT43"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT44"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT45"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP5"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR5"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT51"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT52"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT53"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT54"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT55"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP6"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR6"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT61"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT62"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT63"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT64"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT65"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP7"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR7"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT71"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT72"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT73"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT74"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT75"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP8"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR8"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT81"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT82"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT83"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT84"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT85"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP9"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR9"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT91"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT92"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT93"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT94"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT95"] = " ".PadRight(0 ); 
         dwReturn["KAVKOGRP10"] = " ".PadRight(4 ); 
         dwReturn["KAVVVGKBTR10"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT101"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT102"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT103"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT104"] = " ".PadRight(0 ); 
         dwReturn["KAVVVGKAUFT105"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKG1"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKG2"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKG3"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKG4"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKG5"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKK1"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKK2"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKK3"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKK4"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKK5"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKV1"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKV2"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKV3"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKV4"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKV5"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKKONF1"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKKONF2"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKKONF3"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKKONF4"] = " ".PadRight(0 ); 
         dwReturn["KAVFGKKONF5"] = " ".PadRight(0 ); 
         dwReturn["KAVVERPI"] = " ".PadRight(0 ); 
         dwReturn["KAVVERPE"] = " ".PadRight(0 ); 
         dwReturn["KAVVERSI"] = " ".PadRight(0 ); 
         dwReturn["KAVVERSE"] = " ".PadRight(0 ); 
         dwReturn["KAVFRAI"] = " ".PadRight(0 ); 
         dwReturn["KAVFRAE"] = " ".PadRight(0 ); 
         dwReturn["KAVZOLLI"] = " ".PadRight(0 ); 
         dwReturn["KAVZOLLE"] = " ".PadRight(0 ); 
         dwReturn["KAVPROVI"] = " ".PadRight(0 ); 
         dwReturn["KAVPROVE"] = " ".PadRight(0 ); 
         dwReturn["KAVBONI"] = " ".PadRight(0 ); 
         dwReturn["KAVBONE"] = " ".PadRight(0 ); 
         dwReturn["KAVSKTI"] = " ".PadRight(0 ); 
         dwReturn["KAVSKTE"] = " ".PadRight(0 ); 
         dwReturn["KAVEVI"] = " ".PadRight(0 ); 
         dwReturn["KAVEVE"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKSI"] = " ".PadRight(0 ); 
         dwReturn["KAVSEKSE"] = " ".PadRight(0 ); 
         dwReturn["KAVSDBI"] = " ".PadRight(0 ); 
         dwReturn["KAVSDBE"] = " ".PadRight(0 ); 
         dwReturn["KAVZINSI"] = " ".PadRight(0 ); 
         dwReturn["KAVZINSE"] = " ".PadRight(0 ); 
         dwReturn["KAVSCHK"] = " ".PadRight(0 ); 
         dwReturn["KAVVERPR"] = " ".PadRight(0 ); 
         dwReturn["KAVZUSCHL"] = " ".PadRight(0 ); 
         dwReturn["KAVVERKPR"] = " ".PadRight(0 ); 
         dwReturn["KAVFILLER"] = " ".PadRight(99 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapKAVERF(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveKAVERF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryKAVERF(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapKAVERF(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertKAVERF(dwLocal, ITXDBVERSION);
            }
            UpdateKAVERF(dwLocal);
        }
        public void InsertKAVERF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO KAVERF(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryKAVERF(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM KAVERF WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM KAVERF  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "KAVERF";
            Return = Result;
            return Return;
        }
        public void DeleteKAVERF(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM KAVERF   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateKAVERF(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE KAVERF SET "
                    +"KAVMANDANT= :KAVMANDANT,"
                    +"KAVKANR= :KAVKANR,"
                    +"KAVKAPOS= :KAVKAPOS,"
                    +"KAVPOS= :KAVPOS,"
                    +"KAVWERK= :KAVWERK,"
                    +"KAVANRKR= :KAVANRKR,"
                    +"KAVALFDNR= :KAVALFDNR,"
                    +"KAVAFOV= :KAVAFOV,"
                    +"KAVAFOB= :KAVAFOB,"
                    +"KAVME= :KAVME,"
                    +"KAVMENGE1= :KAVMENGE1,"
                    +"KAVMENGE2= :KAVMENGE2,"
                    +"KAVMENGE3= :KAVMENGE3,"
                    +"KAVMENGE4= :KAVMENGE4,"
                    +"KAVMENGE5= :KAVMENGE5,"
                    +"KAVMENGE6= :KAVMENGE6,"
                    +"KAVMENGE7= :KAVMENGE7,"
                    +"KAVMENGE8= :KAVMENGE8,"
                    +"KAVANRKR2= :KAVANRKR2,"
                    +"KAVALFDNR2= :KAVALFDNR2,"
                    +"KAVAFOV2= :KAVAFOV2,"
                    +"KAVAFOB2= :KAVAFOB2,"
                    +"KAVME2= :KAVME2,"
                    +"KAVMENGE21= :KAVMENGE21,"
                    +"KAVMENGE22= :KAVMENGE22,"
                    +"KAVMENGE23= :KAVMENGE23,"
                    +"KAVMENGE24= :KAVMENGE24,"
                    +"KAVMENGE25= :KAVMENGE25,"
                    +"KAVMENGE26= :KAVMENGE26,"
                    +"KAVMENGE27= :KAVMENGE27,"
                    +"KAVMENGE28= :KAVMENGE28,"
                    +"KAVANRKR3= :KAVANRKR3,"
                    +"KAVALFDNR3= :KAVALFDNR3,"
                    +"KAVAFOV3= :KAVAFOV3,"
                    +"KAVAFOB3= :KAVAFOB3,"
                    +"KAVME3= :KAVME3,"
                    +"KAVMENGE31= :KAVMENGE31,"
                    +"KAVMENGE32= :KAVMENGE32,"
                    +"KAVMENGE33= :KAVMENGE33,"
                    +"KAVMENGE34= :KAVMENGE34,"
                    +"KAVMENGE35= :KAVMENGE35,"
                    +"KAVMENGE36= :KAVMENGE36,"
                    +"KAVMENGE37= :KAVMENGE37,"
                    +"KAVMENGE38= :KAVMENGE38,"
                    +"KAVANRKR4= :KAVANRKR4,"
                    +"KAVALFDNR4= :KAVALFDNR4,"
                    +"KAVAFOV4= :KAVAFOV4,"
                    +"KAVAFOB4= :KAVAFOB4,"
                    +"KAVME4= :KAVME4,"
                    +"KAVMENGE41= :KAVMENGE41,"
                    +"KAVMENGE42= :KAVMENGE42,"
                    +"KAVMENGE43= :KAVMENGE43,"
                    +"KAVMENGE44= :KAVMENGE44,"
                    +"KAVMENGE45= :KAVMENGE45,"
                    +"KAVMENGE46= :KAVMENGE46,"
                    +"KAVMENGE47= :KAVMENGE47,"
                    +"KAVMENGE48= :KAVMENGE48,"
                    +"KAVANRKR5= :KAVANRKR5,"
                    +"KAVALFDNR5= :KAVALFDNR5,"
                    +"KAVAFOV5= :KAVAFOV5,"
                    +"KAVAFOB5= :KAVAFOB5,"
                    +"KAVME5= :KAVME5,"
                    +"KAVMENGE51= :KAVMENGE51,"
                    +"KAVMENGE52= :KAVMENGE52,"
                    +"KAVMENGE53= :KAVMENGE53,"
                    +"KAVMENGE54= :KAVMENGE54,"
                    +"KAVMENGE55= :KAVMENGE55,"
                    +"KAVMENGE56= :KAVMENGE56,"
                    +"KAVMENGE57= :KAVMENGE57,"
                    +"KAVMENGE58= :KAVMENGE58,"
                    +"KAVANRKR6= :KAVANRKR6,"
                    +"KAVALFDNR6= :KAVALFDNR6,"
                    +"KAVAFOV6= :KAVAFOV6,"
                    +"KAVAFOB6= :KAVAFOB6,"
                    +"KAVME6= :KAVME6,"
                    +"KAVMENGE61= :KAVMENGE61,"
                    +"KAVMENGE62= :KAVMENGE62,"
                    +"KAVMENGE63= :KAVMENGE63,"
                    +"KAVMENGE64= :KAVMENGE64,"
                    +"KAVMENGE65= :KAVMENGE65,"
                    +"KAVMENGE66= :KAVMENGE66,"
                    +"KAVMENGE67= :KAVMENGE67,"
                    +"KAVMENGE68= :KAVMENGE68,"
                    +"KAVMIX= :KAVMIX,"
                    +"KAVHK1= :KAVHK1,"
                    +"KAVHK2= :KAVHK2,"
                    +"KAVHK3= :KAVHK3,"
                    +"KAVHK4= :KAVHK4,"
                    +"KAVHK5= :KAVHK5,"
                    +"KAVHK6= :KAVHK6,"
                    +"KAVFE1= :KAVFE1,"
                    +"KAVFE2= :KAVFE2,"
                    +"KAVFE3= :KAVFE3,"
                    +"KAVFE4= :KAVFE4,"
                    +"KAVFE5= :KAVFE5,"
                    +"KAVFE6= :KAVFE6,"
                    +"KAVFE7= :KAVFE7,"
                    +"KAVFE8= :KAVFE8,"
                    +"KAVFE9= :KAVFE9,"
                    +"KAVFE10= :KAVFE10,"
                    +"KAVMKKG= :KAVMKKG,"
                    +"KAVMGKKG1= :KAVMGKKG1,"
                    +"KAVMGKKG2= :KAVMGKKG2,"
                    +"KAVMGKKG3= :KAVMGKKG3,"
                    +"KAVMGKKG4= :KAVMGKKG4,"
                    +"KAVMGKKG5= :KAVMGKKG5,"
                    +"KAVMGKKG6= :KAVMGKKG6,"
                    +"KAVMKSG= :KAVMKSG,"
                    +"KAVMGKSG1= :KAVMGKSG1,"
                    +"KAVMGKSG2= :KAVMGKSG2,"
                    +"KAVMGKSG3= :KAVMGKSG3,"
                    +"KAVMGKSG4= :KAVMGKSG4,"
                    +"KAVMGKSG5= :KAVMGKSG5,"
                    +"KAVMGKSG6= :KAVMGKSG6,"
                    +"KAVMKROHW= :KAVMKROHW,"
                    +"KAVMGKROHW1= :KAVMGKROHW1,"
                    +"KAVMGKROHW2= :KAVMGKROHW2,"
                    +"KAVMGKROHW3= :KAVMGKROHW3,"
                    +"KAVMGKROHW4= :KAVMGKROHW4,"
                    +"KAVMGKROHW5= :KAVMGKROHW5,"
                    +"KAVMGKROHW6= :KAVMGKROHW6,"
                    +"KAVMKREZ= :KAVMKREZ,"
                    +"KAVMGKREZ1= :KAVMGKREZ1,"
                    +"KAVMGKREZ2= :KAVMGKREZ2,"
                    +"KAVMGKREZ3= :KAVMGKREZ3,"
                    +"KAVMGKREZ4= :KAVMGKREZ4,"
                    +"KAVMGKREZ5= :KAVMGKREZ5,"
                    +"KAVMGKREZ6= :KAVMGKREZ6,"
                    +"KAVMKZU= :KAVMKZU,"
                    +"KAVMGKZU1= :KAVMGKZU1,"
                    +"KAVMGKZU2= :KAVMGKZU2,"
                    +"KAVMGKZU3= :KAVMGKZU3,"
                    +"KAVMGKZU4= :KAVMGKZU4,"
                    +"KAVMGKZU5= :KAVMGKZU5,"
                    +"KAVMGKZU6= :KAVMGKZU6,"
                    +"KAVMKSO= :KAVMKSO,"
                    +"KAVMGKSO1= :KAVMGKSO1,"
                    +"KAVMGKSO2= :KAVMGKSO2,"
                    +"KAVMGKSO3= :KAVMGKSO3,"
                    +"KAVMGKSO4= :KAVMGKSO4,"
                    +"KAVMGKSO5= :KAVMGKSO5,"
                    +"KAVMGKSO6= :KAVMGKSO6,"
                    +"KAVFFKG= :KAVFFKG,"
                    +"KAVFEKG1= :KAVFEKG1,"
                    +"KAVFEKG2= :KAVFEKG2,"
                    +"KAVFEKG3= :KAVFEKG3,"
                    +"KAVFEKG4= :KAVFEKG4,"
                    +"KAVFEKG5= :KAVFEKG5,"
                    +"KAVSEKG= :KAVSEKG,"
                    +"KAVFFKK= :KAVFFKK,"
                    +"KAVFEKK1= :KAVFEKK1,"
                    +"KAVFEKK2= :KAVFEKK2,"
                    +"KAVFEKK3= :KAVFEKK3,"
                    +"KAVFEKK4= :KAVFEKK4,"
                    +"KAVFEKK5= :KAVFEKK5,"
                    +"KAVSEKK= :KAVSEKK,"
                    +"KAVFFKROHW= :KAVFFKROHW,"
                    +"KAVFEKROHW1= :KAVFEKROHW1,"
                    +"KAVFEKROHW2= :KAVFEKROHW2,"
                    +"KAVFEKROHW3= :KAVFEKROHW3,"
                    +"KAVFEKROHW4= :KAVFEKROHW4,"
                    +"KAVFEKROHW5= :KAVFEKROHW5,"
                    +"KAVSEKROHW= :KAVSEKROHW,"
                    +"KAVFFKV= :KAVFFKV,"
                    +"KAVFEKV1= :KAVFEKV1,"
                    +"KAVFEKV2= :KAVFEKV2,"
                    +"KAVFEKV3= :KAVFEKV3,"
                    +"KAVFEKV4= :KAVFEKV4,"
                    +"KAVFEKV5= :KAVFEKV5,"
                    +"KAVSEKV= :KAVSEKV,"
                    +"KAVFFKKONF= :KAVFFKKONF,"
                    +"KAVFEKKONF1= :KAVFEKKONF1,"
                    +"KAVFEKKONF2= :KAVFEKKONF2,"
                    +"KAVFEKKONF3= :KAVFEKKONF3,"
                    +"KAVFEKKONF4= :KAVFEKKONF4,"
                    +"KAVFEKKONF5= :KAVFEKKONF5,"
                    +"KAVSEKKONF= :KAVSEKKONF,"
                    +"KAVVVGKTOT1= :KAVVVGKTOT1,"
                    +"KAVVVGK1= :KAVVVGK1,"
                    +"KAVVVGK2= :KAVVVGK2,"
                    +"KAVVVGK3= :KAVVVGK3,"
                    +"KAVVVGK4= :KAVVVGK4,"
                    +"KAVVVGK5= :KAVVVGK5,"
                    +"KAVVVGKTOT2= :KAVVVGKTOT2,"
                    +"KAVLAEV= :KAVLAEV,"
                    +"KAVLAETOT1= :KAVLAETOT1,"
                    +"KAVLAETOT2= :KAVLAETOT2,"
                    +"KAVLAETOT3= :KAVLAETOT3,"
                    +"KAVLAETOT4= :KAVLAETOT4,"
                    +"KAVLAETOT5= :KAVLAETOT5,"
                    +"KAVLAEG= :KAVLAEG,"
                    +"KAVWAGV= :KAVWAGV,"
                    +"KAVWAGTOT1= :KAVWAGTOT1,"
                    +"KAVWAGTOT2= :KAVWAGTOT2,"
                    +"KAVWAGTOT3= :KAVWAGTOT3,"
                    +"KAVWAGTOT4= :KAVWAGTOT4,"
                    +"KAVWAGTOT5= :KAVWAGTOT5,"
                    +"KAVWAGG= :KAVWAGG,"
                    +"KAVMEZV= :KAVMEZV,"
                    +"KAVMEZTOT1= :KAVMEZTOT1,"
                    +"KAVMEZTOT2= :KAVMEZTOT2,"
                    +"KAVMEZTOT3= :KAVMEZTOT3,"
                    +"KAVMEZTOT4= :KAVMEZTOT4,"
                    +"KAVMEZTOT5= :KAVMEZTOT5,"
                    +"KAVMEZG= :KAVMEZG,"
                    +"KAVRESERVE1= :KAVRESERVE1,"
                    +"KAVRESERVE21= :KAVRESERVE21,"
                    +"KAVRESERVE22= :KAVRESERVE22,"
                    +"KAVRESERVE23= :KAVRESERVE23,"
                    +"KAVRESERVE24= :KAVRESERVE24,"
                    +"KAVRESERVE25= :KAVRESERVE25,"
                    +"KAVRESERVE3= :KAVRESERVE3,"
                    +"KAVKOGRP1= :KAVKOGRP1,"
                    +"KAVVVGKBTR1= :KAVVVGKBTR1,"
                    +"KAVVVGKAUFT11= :KAVVVGKAUFT11,"
                    +"KAVVVGKAUFT12= :KAVVVGKAUFT12,"
                    +"KAVVVGKAUFT13= :KAVVVGKAUFT13,"
                    +"KAVVVGKAUFT14= :KAVVVGKAUFT14,"
                    +"KAVVVGKAUFT15= :KAVVVGKAUFT15,"
                    +"KAVKOGRP2= :KAVKOGRP2,"
                    +"KAVVVGKBTR2= :KAVVVGKBTR2,"
                    +"KAVVVGKAUFT21= :KAVVVGKAUFT21,"
                    +"KAVVVGKAUFT22= :KAVVVGKAUFT22,"
                    +"KAVVVGKAUFT23= :KAVVVGKAUFT23,"
                    +"KAVVVGKAUFT24= :KAVVVGKAUFT24,"
                    +"KAVVVGKAUFT25= :KAVVVGKAUFT25,"
                    +"KAVKOGRP3= :KAVKOGRP3,"
                    +"KAVVVGKBTR3= :KAVVVGKBTR3,"
                    +"KAVVVGKAUFT31= :KAVVVGKAUFT31,"
                    +"KAVVVGKAUFT32= :KAVVVGKAUFT32,"
                    +"KAVVVGKAUFT33= :KAVVVGKAUFT33,"
                    +"KAVVVGKAUFT34= :KAVVVGKAUFT34,"
                    +"KAVVVGKAUFT35= :KAVVVGKAUFT35,"
                    +"KAVKOGRP4= :KAVKOGRP4,"
                    +"KAVVVGKBTR4= :KAVVVGKBTR4,"
                    +"KAVVVGKAUFT41= :KAVVVGKAUFT41,"
                    +"KAVVVGKAUFT42= :KAVVVGKAUFT42,"
                    +"KAVVVGKAUFT43= :KAVVVGKAUFT43,"
                    +"KAVVVGKAUFT44= :KAVVVGKAUFT44,"
                    +"KAVVVGKAUFT45= :KAVVVGKAUFT45,"
                    +"KAVKOGRP5= :KAVKOGRP5,"
                    +"KAVVVGKBTR5= :KAVVVGKBTR5,"
                    +"KAVVVGKAUFT51= :KAVVVGKAUFT51,"
                    +"KAVVVGKAUFT52= :KAVVVGKAUFT52,"
                    +"KAVVVGKAUFT53= :KAVVVGKAUFT53,"
                    +"KAVVVGKAUFT54= :KAVVVGKAUFT54,"
                    +"KAVVVGKAUFT55= :KAVVVGKAUFT55,"
                    +"KAVKOGRP6= :KAVKOGRP6,"
                    +"KAVVVGKBTR6= :KAVVVGKBTR6,"
                    +"KAVVVGKAUFT61= :KAVVVGKAUFT61,"
                    +"KAVVVGKAUFT62= :KAVVVGKAUFT62,"
                    +"KAVVVGKAUFT63= :KAVVVGKAUFT63,"
                    +"KAVVVGKAUFT64= :KAVVVGKAUFT64,"
                    +"KAVVVGKAUFT65= :KAVVVGKAUFT65,"
                    +"KAVKOGRP7= :KAVKOGRP7,"
                    +"KAVVVGKBTR7= :KAVVVGKBTR7,"
                    +"KAVVVGKAUFT71= :KAVVVGKAUFT71,"
                    +"KAVVVGKAUFT72= :KAVVVGKAUFT72,"
                    +"KAVVVGKAUFT73= :KAVVVGKAUFT73,"
                    +"KAVVVGKAUFT74= :KAVVVGKAUFT74,"
                    +"KAVVVGKAUFT75= :KAVVVGKAUFT75,"
                    +"KAVKOGRP8= :KAVKOGRP8,"
                    +"KAVVVGKBTR8= :KAVVVGKBTR8,"
                    +"KAVVVGKAUFT81= :KAVVVGKAUFT81,"
                    +"KAVVVGKAUFT82= :KAVVVGKAUFT82,"
                    +"KAVVVGKAUFT83= :KAVVVGKAUFT83,"
                    +"KAVVVGKAUFT84= :KAVVVGKAUFT84,"
                    +"KAVVVGKAUFT85= :KAVVVGKAUFT85,"
                    +"KAVKOGRP9= :KAVKOGRP9,"
                    +"KAVVVGKBTR9= :KAVVVGKBTR9,"
                    +"KAVVVGKAUFT91= :KAVVVGKAUFT91,"
                    +"KAVVVGKAUFT92= :KAVVVGKAUFT92,"
                    +"KAVVVGKAUFT93= :KAVVVGKAUFT93,"
                    +"KAVVVGKAUFT94= :KAVVVGKAUFT94,"
                    +"KAVVVGKAUFT95= :KAVVVGKAUFT95,"
                    +"KAVKOGRP10= :KAVKOGRP10,"
                    +"KAVVVGKBTR10= :KAVVVGKBTR10,"
                    +"KAVVVGKAUFT101= :KAVVVGKAUFT101,"
                    +"KAVVVGKAUFT102= :KAVVVGKAUFT102,"
                    +"KAVVVGKAUFT103= :KAVVVGKAUFT103,"
                    +"KAVVVGKAUFT104= :KAVVVGKAUFT104,"
                    +"KAVVVGKAUFT105= :KAVVVGKAUFT105,"
                    +"KAVFGKG1= :KAVFGKG1,"
                    +"KAVFGKG2= :KAVFGKG2,"
                    +"KAVFGKG3= :KAVFGKG3,"
                    +"KAVFGKG4= :KAVFGKG4,"
                    +"KAVFGKG5= :KAVFGKG5,"
                    +"KAVFGKK1= :KAVFGKK1,"
                    +"KAVFGKK2= :KAVFGKK2,"
                    +"KAVFGKK3= :KAVFGKK3,"
                    +"KAVFGKK4= :KAVFGKK4,"
                    +"KAVFGKK5= :KAVFGKK5,"
                    +"KAVFGKROHW1= :KAVFGKROHW1,"
                    +"KAVFGKROHW2= :KAVFGKROHW2,"
                    +"KAVFGKROHW3= :KAVFGKROHW3,"
                    +"KAVFGKROHW4= :KAVFGKROHW4,"
                    +"KAVFGKROHW5= :KAVFGKROHW5,"
                    +"KAVFGKV1= :KAVFGKV1,"
                    +"KAVFGKV2= :KAVFGKV2,"
                    +"KAVFGKV3= :KAVFGKV3,"
                    +"KAVFGKV4= :KAVFGKV4,"
                    +"KAVFGKV5= :KAVFGKV5,"
                    +"KAVFGKKONF1= :KAVFGKKONF1,"
                    +"KAVFGKKONF2= :KAVFGKKONF2,"
                    +"KAVFGKKONF3= :KAVFGKKONF3,"
                    +"KAVFGKKONF4= :KAVFGKKONF4,"
                    +"KAVFGKKONF5= :KAVFGKKONF5,"
                    +"KAVVERPI= :KAVVERPI,"
                    +"KAVVERPE= :KAVVERPE,"
                    +"KAVVERSI= :KAVVERSI,"
                    +"KAVVERSE= :KAVVERSE,"
                    +"KAVFRAI= :KAVFRAI,"
                    +"KAVFRAE= :KAVFRAE,"
                    +"KAVZOLLI= :KAVZOLLI,"
                    +"KAVZOLLE= :KAVZOLLE,"
                    +"KAVPROVI= :KAVPROVI,"
                    +"KAVPROVE= :KAVPROVE,"
                    +"KAVBONI= :KAVBONI,"
                    +"KAVBONE= :KAVBONE,"
                    +"KAVSKTI= :KAVSKTI,"
                    +"KAVSKTE= :KAVSKTE,"
                    +"KAVEVI= :KAVEVI,"
                    +"KAVEVE= :KAVEVE,"
                    +"KAVSEKSI= :KAVSEKSI,"
                    +"KAVSEKSE= :KAVSEKSE,"
                    +"KAVSDBI= :KAVSDBI,"
                    +"KAVSDBE= :KAVSDBE,"
                    +"KAVZINSI= :KAVZINSI,"
                    +"KAVZINSE= :KAVZINSE,"
                    +"KAVSCHK= :KAVSCHK,"
                    +"KAVVERPR= :KAVVERPR,"
                    +"KAVZUSCHL= :KAVZUSCHL,"
                    +"KAVVERKPR= :KAVVERKPR,"
                    +"KAVFILLER= :KAVFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("KAVMANDANT", OracleType.NVarChar).Value = dwData["KAVMANDANT"].ToString(); 
          or1.Parameters.Add("KAVKANR", OracleType.NVarChar).Value = dwData["KAVKANR"].ToString(); 
          or1.Parameters.Add("KAVKAPOS", OracleType.NVarChar).Value = dwData["KAVKAPOS"].ToString(); 
          or1.Parameters.Add("KAVPOS", OracleType.NVarChar).Value = dwData["KAVPOS"].ToString(); 
          or1.Parameters.Add("KAVWERK", OracleType.NVarChar).Value = dwData["KAVWERK"].ToString(); 
          or1.Parameters.Add("KAVANRKR", OracleType.NVarChar).Value = dwData["KAVANRKR"].ToString(); 
          or1.Parameters.Add("KAVALFDNR", OracleType.NVarChar).Value = dwData["KAVALFDNR"].ToString(); 
          or1.Parameters.Add("KAVAFOV", OracleType.NVarChar).Value = dwData["KAVAFOV"].ToString(); 
          or1.Parameters.Add("KAVAFOB", OracleType.NVarChar).Value = dwData["KAVAFOB"].ToString(); 
          or1.Parameters.Add("KAVME", OracleType.NVarChar).Value = dwData["KAVME"].ToString(); 
          or1.Parameters.Add("KAVMENGE1", OracleType.NVarChar).Value = dwData["KAVMENGE1"].ToString(); 
          or1.Parameters.Add("KAVMENGE2", OracleType.NVarChar).Value = dwData["KAVMENGE2"].ToString(); 
          or1.Parameters.Add("KAVMENGE3", OracleType.NVarChar).Value = dwData["KAVMENGE3"].ToString(); 
          or1.Parameters.Add("KAVMENGE4", OracleType.NVarChar).Value = dwData["KAVMENGE4"].ToString(); 
          or1.Parameters.Add("KAVMENGE5", OracleType.NVarChar).Value = dwData["KAVMENGE5"].ToString(); 
          or1.Parameters.Add("KAVMENGE6", OracleType.NVarChar).Value = dwData["KAVMENGE6"].ToString(); 
          or1.Parameters.Add("KAVMENGE7", OracleType.NVarChar).Value = dwData["KAVMENGE7"].ToString(); 
          or1.Parameters.Add("KAVMENGE8", OracleType.NVarChar).Value = dwData["KAVMENGE8"].ToString(); 
          or1.Parameters.Add("KAVANRKR2", OracleType.NVarChar).Value = dwData["KAVANRKR2"].ToString(); 
          or1.Parameters.Add("KAVALFDNR2", OracleType.NVarChar).Value = dwData["KAVALFDNR2"].ToString(); 
          or1.Parameters.Add("KAVAFOV2", OracleType.NVarChar).Value = dwData["KAVAFOV2"].ToString(); 
          or1.Parameters.Add("KAVAFOB2", OracleType.NVarChar).Value = dwData["KAVAFOB2"].ToString(); 
          or1.Parameters.Add("KAVME2", OracleType.NVarChar).Value = dwData["KAVME2"].ToString(); 
          or1.Parameters.Add("KAVMENGE21", OracleType.NVarChar).Value = dwData["KAVMENGE21"].ToString(); 
          or1.Parameters.Add("KAVMENGE22", OracleType.NVarChar).Value = dwData["KAVMENGE22"].ToString(); 
          or1.Parameters.Add("KAVMENGE23", OracleType.NVarChar).Value = dwData["KAVMENGE23"].ToString(); 
          or1.Parameters.Add("KAVMENGE24", OracleType.NVarChar).Value = dwData["KAVMENGE24"].ToString(); 
          or1.Parameters.Add("KAVMENGE25", OracleType.NVarChar).Value = dwData["KAVMENGE25"].ToString(); 
          or1.Parameters.Add("KAVMENGE26", OracleType.NVarChar).Value = dwData["KAVMENGE26"].ToString(); 
          or1.Parameters.Add("KAVMENGE27", OracleType.NVarChar).Value = dwData["KAVMENGE27"].ToString(); 
          or1.Parameters.Add("KAVMENGE28", OracleType.NVarChar).Value = dwData["KAVMENGE28"].ToString(); 
          or1.Parameters.Add("KAVANRKR3", OracleType.NVarChar).Value = dwData["KAVANRKR3"].ToString(); 
          or1.Parameters.Add("KAVALFDNR3", OracleType.NVarChar).Value = dwData["KAVALFDNR3"].ToString(); 
          or1.Parameters.Add("KAVAFOV3", OracleType.NVarChar).Value = dwData["KAVAFOV3"].ToString(); 
          or1.Parameters.Add("KAVAFOB3", OracleType.NVarChar).Value = dwData["KAVAFOB3"].ToString(); 
          or1.Parameters.Add("KAVME3", OracleType.NVarChar).Value = dwData["KAVME3"].ToString(); 
          or1.Parameters.Add("KAVMENGE31", OracleType.NVarChar).Value = dwData["KAVMENGE31"].ToString(); 
          or1.Parameters.Add("KAVMENGE32", OracleType.NVarChar).Value = dwData["KAVMENGE32"].ToString(); 
          or1.Parameters.Add("KAVMENGE33", OracleType.NVarChar).Value = dwData["KAVMENGE33"].ToString(); 
          or1.Parameters.Add("KAVMENGE34", OracleType.NVarChar).Value = dwData["KAVMENGE34"].ToString(); 
          or1.Parameters.Add("KAVMENGE35", OracleType.NVarChar).Value = dwData["KAVMENGE35"].ToString(); 
          or1.Parameters.Add("KAVMENGE36", OracleType.NVarChar).Value = dwData["KAVMENGE36"].ToString(); 
          or1.Parameters.Add("KAVMENGE37", OracleType.NVarChar).Value = dwData["KAVMENGE37"].ToString(); 
          or1.Parameters.Add("KAVMENGE38", OracleType.NVarChar).Value = dwData["KAVMENGE38"].ToString(); 
          or1.Parameters.Add("KAVANRKR4", OracleType.NVarChar).Value = dwData["KAVANRKR4"].ToString(); 
          or1.Parameters.Add("KAVALFDNR4", OracleType.NVarChar).Value = dwData["KAVALFDNR4"].ToString(); 
          or1.Parameters.Add("KAVAFOV4", OracleType.NVarChar).Value = dwData["KAVAFOV4"].ToString(); 
          or1.Parameters.Add("KAVAFOB4", OracleType.NVarChar).Value = dwData["KAVAFOB4"].ToString(); 
          or1.Parameters.Add("KAVME4", OracleType.NVarChar).Value = dwData["KAVME4"].ToString(); 
          or1.Parameters.Add("KAVMENGE41", OracleType.NVarChar).Value = dwData["KAVMENGE41"].ToString(); 
          or1.Parameters.Add("KAVMENGE42", OracleType.NVarChar).Value = dwData["KAVMENGE42"].ToString(); 
          or1.Parameters.Add("KAVMENGE43", OracleType.NVarChar).Value = dwData["KAVMENGE43"].ToString(); 
          or1.Parameters.Add("KAVMENGE44", OracleType.NVarChar).Value = dwData["KAVMENGE44"].ToString(); 
          or1.Parameters.Add("KAVMENGE45", OracleType.NVarChar).Value = dwData["KAVMENGE45"].ToString(); 
          or1.Parameters.Add("KAVMENGE46", OracleType.NVarChar).Value = dwData["KAVMENGE46"].ToString(); 
          or1.Parameters.Add("KAVMENGE47", OracleType.NVarChar).Value = dwData["KAVMENGE47"].ToString(); 
          or1.Parameters.Add("KAVMENGE48", OracleType.NVarChar).Value = dwData["KAVMENGE48"].ToString(); 
          or1.Parameters.Add("KAVANRKR5", OracleType.NVarChar).Value = dwData["KAVANRKR5"].ToString(); 
          or1.Parameters.Add("KAVALFDNR5", OracleType.NVarChar).Value = dwData["KAVALFDNR5"].ToString(); 
          or1.Parameters.Add("KAVAFOV5", OracleType.NVarChar).Value = dwData["KAVAFOV5"].ToString(); 
          or1.Parameters.Add("KAVAFOB5", OracleType.NVarChar).Value = dwData["KAVAFOB5"].ToString(); 
          or1.Parameters.Add("KAVME5", OracleType.NVarChar).Value = dwData["KAVME5"].ToString(); 
          or1.Parameters.Add("KAVMENGE51", OracleType.NVarChar).Value = dwData["KAVMENGE51"].ToString(); 
          or1.Parameters.Add("KAVMENGE52", OracleType.NVarChar).Value = dwData["KAVMENGE52"].ToString(); 
          or1.Parameters.Add("KAVMENGE53", OracleType.NVarChar).Value = dwData["KAVMENGE53"].ToString(); 
          or1.Parameters.Add("KAVMENGE54", OracleType.NVarChar).Value = dwData["KAVMENGE54"].ToString(); 
          or1.Parameters.Add("KAVMENGE55", OracleType.NVarChar).Value = dwData["KAVMENGE55"].ToString(); 
          or1.Parameters.Add("KAVMENGE56", OracleType.NVarChar).Value = dwData["KAVMENGE56"].ToString(); 
          or1.Parameters.Add("KAVMENGE57", OracleType.NVarChar).Value = dwData["KAVMENGE57"].ToString(); 
          or1.Parameters.Add("KAVMENGE58", OracleType.NVarChar).Value = dwData["KAVMENGE58"].ToString(); 
          or1.Parameters.Add("KAVANRKR6", OracleType.NVarChar).Value = dwData["KAVANRKR6"].ToString(); 
          or1.Parameters.Add("KAVALFDNR6", OracleType.NVarChar).Value = dwData["KAVALFDNR6"].ToString(); 
          or1.Parameters.Add("KAVAFOV6", OracleType.NVarChar).Value = dwData["KAVAFOV6"].ToString(); 
          or1.Parameters.Add("KAVAFOB6", OracleType.NVarChar).Value = dwData["KAVAFOB6"].ToString(); 
          or1.Parameters.Add("KAVME6", OracleType.NVarChar).Value = dwData["KAVME6"].ToString(); 
          or1.Parameters.Add("KAVMENGE61", OracleType.NVarChar).Value = dwData["KAVMENGE61"].ToString(); 
          or1.Parameters.Add("KAVMENGE62", OracleType.NVarChar).Value = dwData["KAVMENGE62"].ToString(); 
          or1.Parameters.Add("KAVMENGE63", OracleType.NVarChar).Value = dwData["KAVMENGE63"].ToString(); 
          or1.Parameters.Add("KAVMENGE64", OracleType.NVarChar).Value = dwData["KAVMENGE64"].ToString(); 
          or1.Parameters.Add("KAVMENGE65", OracleType.NVarChar).Value = dwData["KAVMENGE65"].ToString(); 
          or1.Parameters.Add("KAVMENGE66", OracleType.NVarChar).Value = dwData["KAVMENGE66"].ToString(); 
          or1.Parameters.Add("KAVMENGE67", OracleType.NVarChar).Value = dwData["KAVMENGE67"].ToString(); 
          or1.Parameters.Add("KAVMENGE68", OracleType.NVarChar).Value = dwData["KAVMENGE68"].ToString(); 
          or1.Parameters.Add("KAVMIX", OracleType.NVarChar).Value = dwData["KAVMIX"].ToString(); 
          or1.Parameters.Add("KAVHK1", OracleType.NVarChar).Value = dwData["KAVHK1"].ToString(); 
          or1.Parameters.Add("KAVHK2", OracleType.NVarChar).Value = dwData["KAVHK2"].ToString(); 
          or1.Parameters.Add("KAVHK3", OracleType.NVarChar).Value = dwData["KAVHK3"].ToString(); 
          or1.Parameters.Add("KAVHK4", OracleType.NVarChar).Value = dwData["KAVHK4"].ToString(); 
          or1.Parameters.Add("KAVHK5", OracleType.NVarChar).Value = dwData["KAVHK5"].ToString(); 
          or1.Parameters.Add("KAVHK6", OracleType.NVarChar).Value = dwData["KAVHK6"].ToString(); 
          or1.Parameters.Add("KAVFE1", OracleType.NVarChar).Value = dwData["KAVFE1"].ToString(); 
          or1.Parameters.Add("KAVFE2", OracleType.NVarChar).Value = dwData["KAVFE2"].ToString(); 
          or1.Parameters.Add("KAVFE3", OracleType.NVarChar).Value = dwData["KAVFE3"].ToString(); 
          or1.Parameters.Add("KAVFE4", OracleType.NVarChar).Value = dwData["KAVFE4"].ToString(); 
          or1.Parameters.Add("KAVFE5", OracleType.NVarChar).Value = dwData["KAVFE5"].ToString(); 
          or1.Parameters.Add("KAVFE6", OracleType.NVarChar).Value = dwData["KAVFE6"].ToString(); 
          or1.Parameters.Add("KAVFE7", OracleType.NVarChar).Value = dwData["KAVFE7"].ToString(); 
          or1.Parameters.Add("KAVFE8", OracleType.NVarChar).Value = dwData["KAVFE8"].ToString(); 
          or1.Parameters.Add("KAVFE9", OracleType.NVarChar).Value = dwData["KAVFE9"].ToString(); 
          or1.Parameters.Add("KAVFE10", OracleType.NVarChar).Value = dwData["KAVFE10"].ToString(); 
          or1.Parameters.Add("KAVMKKG", OracleType.NVarChar).Value = dwData["KAVMKKG"].ToString(); 
          or1.Parameters.Add("KAVMGKKG1", OracleType.NVarChar).Value = dwData["KAVMGKKG1"].ToString(); 
          or1.Parameters.Add("KAVMGKKG2", OracleType.NVarChar).Value = dwData["KAVMGKKG2"].ToString(); 
          or1.Parameters.Add("KAVMGKKG3", OracleType.NVarChar).Value = dwData["KAVMGKKG3"].ToString(); 
          or1.Parameters.Add("KAVMGKKG4", OracleType.NVarChar).Value = dwData["KAVMGKKG4"].ToString(); 
          or1.Parameters.Add("KAVMGKKG5", OracleType.NVarChar).Value = dwData["KAVMGKKG5"].ToString(); 
          or1.Parameters.Add("KAVMGKKG6", OracleType.NVarChar).Value = dwData["KAVMGKKG6"].ToString(); 
          or1.Parameters.Add("KAVMKSG", OracleType.NVarChar).Value = dwData["KAVMKSG"].ToString(); 
          or1.Parameters.Add("KAVMGKSG1", OracleType.NVarChar).Value = dwData["KAVMGKSG1"].ToString(); 
          or1.Parameters.Add("KAVMGKSG2", OracleType.NVarChar).Value = dwData["KAVMGKSG2"].ToString(); 
          or1.Parameters.Add("KAVMGKSG3", OracleType.NVarChar).Value = dwData["KAVMGKSG3"].ToString(); 
          or1.Parameters.Add("KAVMGKSG4", OracleType.NVarChar).Value = dwData["KAVMGKSG4"].ToString(); 
          or1.Parameters.Add("KAVMGKSG5", OracleType.NVarChar).Value = dwData["KAVMGKSG5"].ToString(); 
          or1.Parameters.Add("KAVMGKSG6", OracleType.NVarChar).Value = dwData["KAVMGKSG6"].ToString(); 
          or1.Parameters.Add("KAVMKROHW", OracleType.NVarChar).Value = dwData["KAVMKROHW"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW1", OracleType.NVarChar).Value = dwData["KAVMGKROHW1"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW2", OracleType.NVarChar).Value = dwData["KAVMGKROHW2"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW3", OracleType.NVarChar).Value = dwData["KAVMGKROHW3"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW4", OracleType.NVarChar).Value = dwData["KAVMGKROHW4"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW5", OracleType.NVarChar).Value = dwData["KAVMGKROHW5"].ToString(); 
          or1.Parameters.Add("KAVMGKROHW6", OracleType.NVarChar).Value = dwData["KAVMGKROHW6"].ToString(); 
          or1.Parameters.Add("KAVMKREZ", OracleType.NVarChar).Value = dwData["KAVMKREZ"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ1", OracleType.NVarChar).Value = dwData["KAVMGKREZ1"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ2", OracleType.NVarChar).Value = dwData["KAVMGKREZ2"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ3", OracleType.NVarChar).Value = dwData["KAVMGKREZ3"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ4", OracleType.NVarChar).Value = dwData["KAVMGKREZ4"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ5", OracleType.NVarChar).Value = dwData["KAVMGKREZ5"].ToString(); 
          or1.Parameters.Add("KAVMGKREZ6", OracleType.NVarChar).Value = dwData["KAVMGKREZ6"].ToString(); 
          or1.Parameters.Add("KAVMKZU", OracleType.NVarChar).Value = dwData["KAVMKZU"].ToString(); 
          or1.Parameters.Add("KAVMGKZU1", OracleType.NVarChar).Value = dwData["KAVMGKZU1"].ToString(); 
          or1.Parameters.Add("KAVMGKZU2", OracleType.NVarChar).Value = dwData["KAVMGKZU2"].ToString(); 
          or1.Parameters.Add("KAVMGKZU3", OracleType.NVarChar).Value = dwData["KAVMGKZU3"].ToString(); 
          or1.Parameters.Add("KAVMGKZU4", OracleType.NVarChar).Value = dwData["KAVMGKZU4"].ToString(); 
          or1.Parameters.Add("KAVMGKZU5", OracleType.NVarChar).Value = dwData["KAVMGKZU5"].ToString(); 
          or1.Parameters.Add("KAVMGKZU6", OracleType.NVarChar).Value = dwData["KAVMGKZU6"].ToString(); 
          or1.Parameters.Add("KAVMKSO", OracleType.NVarChar).Value = dwData["KAVMKSO"].ToString(); 
          or1.Parameters.Add("KAVMGKSO1", OracleType.NVarChar).Value = dwData["KAVMGKSO1"].ToString(); 
          or1.Parameters.Add("KAVMGKSO2", OracleType.NVarChar).Value = dwData["KAVMGKSO2"].ToString(); 
          or1.Parameters.Add("KAVMGKSO3", OracleType.NVarChar).Value = dwData["KAVMGKSO3"].ToString(); 
          or1.Parameters.Add("KAVMGKSO4", OracleType.NVarChar).Value = dwData["KAVMGKSO4"].ToString(); 
          or1.Parameters.Add("KAVMGKSO5", OracleType.NVarChar).Value = dwData["KAVMGKSO5"].ToString(); 
          or1.Parameters.Add("KAVMGKSO6", OracleType.NVarChar).Value = dwData["KAVMGKSO6"].ToString(); 
          or1.Parameters.Add("KAVFFKG", OracleType.NVarChar).Value = dwData["KAVFFKG"].ToString(); 
          or1.Parameters.Add("KAVFEKG1", OracleType.NVarChar).Value = dwData["KAVFEKG1"].ToString(); 
          or1.Parameters.Add("KAVFEKG2", OracleType.NVarChar).Value = dwData["KAVFEKG2"].ToString(); 
          or1.Parameters.Add("KAVFEKG3", OracleType.NVarChar).Value = dwData["KAVFEKG3"].ToString(); 
          or1.Parameters.Add("KAVFEKG4", OracleType.NVarChar).Value = dwData["KAVFEKG4"].ToString(); 
          or1.Parameters.Add("KAVFEKG5", OracleType.NVarChar).Value = dwData["KAVFEKG5"].ToString(); 
          or1.Parameters.Add("KAVSEKG", OracleType.NVarChar).Value = dwData["KAVSEKG"].ToString(); 
          or1.Parameters.Add("KAVFFKK", OracleType.NVarChar).Value = dwData["KAVFFKK"].ToString(); 
          or1.Parameters.Add("KAVFEKK1", OracleType.NVarChar).Value = dwData["KAVFEKK1"].ToString(); 
          or1.Parameters.Add("KAVFEKK2", OracleType.NVarChar).Value = dwData["KAVFEKK2"].ToString(); 
          or1.Parameters.Add("KAVFEKK3", OracleType.NVarChar).Value = dwData["KAVFEKK3"].ToString(); 
          or1.Parameters.Add("KAVFEKK4", OracleType.NVarChar).Value = dwData["KAVFEKK4"].ToString(); 
          or1.Parameters.Add("KAVFEKK5", OracleType.NVarChar).Value = dwData["KAVFEKK5"].ToString(); 
          or1.Parameters.Add("KAVSEKK", OracleType.NVarChar).Value = dwData["KAVSEKK"].ToString(); 
          or1.Parameters.Add("KAVFFKROHW", OracleType.NVarChar).Value = dwData["KAVFFKROHW"].ToString(); 
          or1.Parameters.Add("KAVFEKROHW1", OracleType.NVarChar).Value = dwData["KAVFEKROHW1"].ToString(); 
          or1.Parameters.Add("KAVFEKROHW2", OracleType.NVarChar).Value = dwData["KAVFEKROHW2"].ToString(); 
          or1.Parameters.Add("KAVFEKROHW3", OracleType.NVarChar).Value = dwData["KAVFEKROHW3"].ToString(); 
          or1.Parameters.Add("KAVFEKROHW4", OracleType.NVarChar).Value = dwData["KAVFEKROHW4"].ToString(); 
          or1.Parameters.Add("KAVFEKROHW5", OracleType.NVarChar).Value = dwData["KAVFEKROHW5"].ToString(); 
          or1.Parameters.Add("KAVSEKROHW", OracleType.NVarChar).Value = dwData["KAVSEKROHW"].ToString(); 
          or1.Parameters.Add("KAVFFKV", OracleType.NVarChar).Value = dwData["KAVFFKV"].ToString(); 
          or1.Parameters.Add("KAVFEKV1", OracleType.NVarChar).Value = dwData["KAVFEKV1"].ToString(); 
          or1.Parameters.Add("KAVFEKV2", OracleType.NVarChar).Value = dwData["KAVFEKV2"].ToString(); 
          or1.Parameters.Add("KAVFEKV3", OracleType.NVarChar).Value = dwData["KAVFEKV3"].ToString(); 
          or1.Parameters.Add("KAVFEKV4", OracleType.NVarChar).Value = dwData["KAVFEKV4"].ToString(); 
          or1.Parameters.Add("KAVFEKV5", OracleType.NVarChar).Value = dwData["KAVFEKV5"].ToString(); 
          or1.Parameters.Add("KAVSEKV", OracleType.NVarChar).Value = dwData["KAVSEKV"].ToString(); 
          or1.Parameters.Add("KAVFFKKONF", OracleType.NVarChar).Value = dwData["KAVFFKKONF"].ToString(); 
          or1.Parameters.Add("KAVFEKKONF1", OracleType.NVarChar).Value = dwData["KAVFEKKONF1"].ToString(); 
          or1.Parameters.Add("KAVFEKKONF2", OracleType.NVarChar).Value = dwData["KAVFEKKONF2"].ToString(); 
          or1.Parameters.Add("KAVFEKKONF3", OracleType.NVarChar).Value = dwData["KAVFEKKONF3"].ToString(); 
          or1.Parameters.Add("KAVFEKKONF4", OracleType.NVarChar).Value = dwData["KAVFEKKONF4"].ToString(); 
          or1.Parameters.Add("KAVFEKKONF5", OracleType.NVarChar).Value = dwData["KAVFEKKONF5"].ToString(); 
          or1.Parameters.Add("KAVSEKKONF", OracleType.NVarChar).Value = dwData["KAVSEKKONF"].ToString(); 
          or1.Parameters.Add("KAVVVGKTOT1", OracleType.NVarChar).Value = dwData["KAVVVGKTOT1"].ToString(); 
          or1.Parameters.Add("KAVVVGK1", OracleType.NVarChar).Value = dwData["KAVVVGK1"].ToString(); 
          or1.Parameters.Add("KAVVVGK2", OracleType.NVarChar).Value = dwData["KAVVVGK2"].ToString(); 
          or1.Parameters.Add("KAVVVGK3", OracleType.NVarChar).Value = dwData["KAVVVGK3"].ToString(); 
          or1.Parameters.Add("KAVVVGK4", OracleType.NVarChar).Value = dwData["KAVVVGK4"].ToString(); 
          or1.Parameters.Add("KAVVVGK5", OracleType.NVarChar).Value = dwData["KAVVVGK5"].ToString(); 
          or1.Parameters.Add("KAVVVGKTOT2", OracleType.NVarChar).Value = dwData["KAVVVGKTOT2"].ToString(); 
          or1.Parameters.Add("KAVLAEV", OracleType.NVarChar).Value = dwData["KAVLAEV"].ToString(); 
          or1.Parameters.Add("KAVLAETOT1", OracleType.NVarChar).Value = dwData["KAVLAETOT1"].ToString(); 
          or1.Parameters.Add("KAVLAETOT2", OracleType.NVarChar).Value = dwData["KAVLAETOT2"].ToString(); 
          or1.Parameters.Add("KAVLAETOT3", OracleType.NVarChar).Value = dwData["KAVLAETOT3"].ToString(); 
          or1.Parameters.Add("KAVLAETOT4", OracleType.NVarChar).Value = dwData["KAVLAETOT4"].ToString(); 
          or1.Parameters.Add("KAVLAETOT5", OracleType.NVarChar).Value = dwData["KAVLAETOT5"].ToString(); 
          or1.Parameters.Add("KAVLAEG", OracleType.NVarChar).Value = dwData["KAVLAEG"].ToString(); 
          or1.Parameters.Add("KAVWAGV", OracleType.NVarChar).Value = dwData["KAVWAGV"].ToString(); 
          or1.Parameters.Add("KAVWAGTOT1", OracleType.NVarChar).Value = dwData["KAVWAGTOT1"].ToString(); 
          or1.Parameters.Add("KAVWAGTOT2", OracleType.NVarChar).Value = dwData["KAVWAGTOT2"].ToString(); 
          or1.Parameters.Add("KAVWAGTOT3", OracleType.NVarChar).Value = dwData["KAVWAGTOT3"].ToString(); 
          or1.Parameters.Add("KAVWAGTOT4", OracleType.NVarChar).Value = dwData["KAVWAGTOT4"].ToString(); 
          or1.Parameters.Add("KAVWAGTOT5", OracleType.NVarChar).Value = dwData["KAVWAGTOT5"].ToString(); 
          or1.Parameters.Add("KAVWAGG", OracleType.NVarChar).Value = dwData["KAVWAGG"].ToString(); 
          or1.Parameters.Add("KAVMEZV", OracleType.NVarChar).Value = dwData["KAVMEZV"].ToString(); 
          or1.Parameters.Add("KAVMEZTOT1", OracleType.NVarChar).Value = dwData["KAVMEZTOT1"].ToString(); 
          or1.Parameters.Add("KAVMEZTOT2", OracleType.NVarChar).Value = dwData["KAVMEZTOT2"].ToString(); 
          or1.Parameters.Add("KAVMEZTOT3", OracleType.NVarChar).Value = dwData["KAVMEZTOT3"].ToString(); 
          or1.Parameters.Add("KAVMEZTOT4", OracleType.NVarChar).Value = dwData["KAVMEZTOT4"].ToString(); 
          or1.Parameters.Add("KAVMEZTOT5", OracleType.NVarChar).Value = dwData["KAVMEZTOT5"].ToString(); 
          or1.Parameters.Add("KAVMEZG", OracleType.NVarChar).Value = dwData["KAVMEZG"].ToString(); 
          or1.Parameters.Add("KAVRESERVE1", OracleType.NVarChar).Value = dwData["KAVRESERVE1"].ToString(); 
          or1.Parameters.Add("KAVRESERVE21", OracleType.NVarChar).Value = dwData["KAVRESERVE21"].ToString(); 
          or1.Parameters.Add("KAVRESERVE22", OracleType.NVarChar).Value = dwData["KAVRESERVE22"].ToString(); 
          or1.Parameters.Add("KAVRESERVE23", OracleType.NVarChar).Value = dwData["KAVRESERVE23"].ToString(); 
          or1.Parameters.Add("KAVRESERVE24", OracleType.NVarChar).Value = dwData["KAVRESERVE24"].ToString(); 
          or1.Parameters.Add("KAVRESERVE25", OracleType.NVarChar).Value = dwData["KAVRESERVE25"].ToString(); 
          or1.Parameters.Add("KAVRESERVE3", OracleType.NVarChar).Value = dwData["KAVRESERVE3"].ToString(); 
          or1.Parameters.Add("KAVKOGRP1", OracleType.NVarChar).Value = dwData["KAVKOGRP1"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR1", OracleType.NVarChar).Value = dwData["KAVVVGKBTR1"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT11", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT11"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT12", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT12"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT13", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT13"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT14", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT14"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT15", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT15"].ToString(); 
          or1.Parameters.Add("KAVKOGRP2", OracleType.NVarChar).Value = dwData["KAVKOGRP2"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR2", OracleType.NVarChar).Value = dwData["KAVVVGKBTR2"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT21", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT21"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT22", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT22"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT23", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT23"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT24", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT24"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT25", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT25"].ToString(); 
          or1.Parameters.Add("KAVKOGRP3", OracleType.NVarChar).Value = dwData["KAVKOGRP3"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR3", OracleType.NVarChar).Value = dwData["KAVVVGKBTR3"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT31", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT31"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT32", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT32"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT33", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT33"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT34", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT34"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT35", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT35"].ToString(); 
          or1.Parameters.Add("KAVKOGRP4", OracleType.NVarChar).Value = dwData["KAVKOGRP4"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR4", OracleType.NVarChar).Value = dwData["KAVVVGKBTR4"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT41", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT41"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT42", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT42"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT43", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT43"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT44", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT44"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT45", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT45"].ToString(); 
          or1.Parameters.Add("KAVKOGRP5", OracleType.NVarChar).Value = dwData["KAVKOGRP5"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR5", OracleType.NVarChar).Value = dwData["KAVVVGKBTR5"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT51", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT51"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT52", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT52"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT53", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT53"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT54", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT54"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT55", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT55"].ToString(); 
          or1.Parameters.Add("KAVKOGRP6", OracleType.NVarChar).Value = dwData["KAVKOGRP6"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR6", OracleType.NVarChar).Value = dwData["KAVVVGKBTR6"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT61", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT61"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT62", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT62"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT63", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT63"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT64", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT64"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT65", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT65"].ToString(); 
          or1.Parameters.Add("KAVKOGRP7", OracleType.NVarChar).Value = dwData["KAVKOGRP7"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR7", OracleType.NVarChar).Value = dwData["KAVVVGKBTR7"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT71", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT71"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT72", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT72"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT73", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT73"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT74", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT74"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT75", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT75"].ToString(); 
          or1.Parameters.Add("KAVKOGRP8", OracleType.NVarChar).Value = dwData["KAVKOGRP8"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR8", OracleType.NVarChar).Value = dwData["KAVVVGKBTR8"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT81", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT81"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT82", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT82"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT83", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT83"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT84", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT84"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT85", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT85"].ToString(); 
          or1.Parameters.Add("KAVKOGRP9", OracleType.NVarChar).Value = dwData["KAVKOGRP9"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR9", OracleType.NVarChar).Value = dwData["KAVVVGKBTR9"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT91", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT91"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT92", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT92"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT93", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT93"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT94", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT94"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT95", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT95"].ToString(); 
          or1.Parameters.Add("KAVKOGRP10", OracleType.NVarChar).Value = dwData["KAVKOGRP10"].ToString(); 
          or1.Parameters.Add("KAVVVGKBTR10", OracleType.NVarChar).Value = dwData["KAVVVGKBTR10"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT101", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT101"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT102", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT102"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT103", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT103"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT104", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT104"].ToString(); 
          or1.Parameters.Add("KAVVVGKAUFT105", OracleType.NVarChar).Value = dwData["KAVVVGKAUFT105"].ToString(); 
          or1.Parameters.Add("KAVFGKG1", OracleType.NVarChar).Value = dwData["KAVFGKG1"].ToString(); 
          or1.Parameters.Add("KAVFGKG2", OracleType.NVarChar).Value = dwData["KAVFGKG2"].ToString(); 
          or1.Parameters.Add("KAVFGKG3", OracleType.NVarChar).Value = dwData["KAVFGKG3"].ToString(); 
          or1.Parameters.Add("KAVFGKG4", OracleType.NVarChar).Value = dwData["KAVFGKG4"].ToString(); 
          or1.Parameters.Add("KAVFGKG5", OracleType.NVarChar).Value = dwData["KAVFGKG5"].ToString(); 
          or1.Parameters.Add("KAVFGKK1", OracleType.NVarChar).Value = dwData["KAVFGKK1"].ToString(); 
          or1.Parameters.Add("KAVFGKK2", OracleType.NVarChar).Value = dwData["KAVFGKK2"].ToString(); 
          or1.Parameters.Add("KAVFGKK3", OracleType.NVarChar).Value = dwData["KAVFGKK3"].ToString(); 
          or1.Parameters.Add("KAVFGKK4", OracleType.NVarChar).Value = dwData["KAVFGKK4"].ToString(); 
          or1.Parameters.Add("KAVFGKK5", OracleType.NVarChar).Value = dwData["KAVFGKK5"].ToString(); 
          or1.Parameters.Add("KAVFGKROHW1", OracleType.NVarChar).Value = dwData["KAVFGKROHW1"].ToString(); 
          or1.Parameters.Add("KAVFGKROHW2", OracleType.NVarChar).Value = dwData["KAVFGKROHW2"].ToString(); 
          or1.Parameters.Add("KAVFGKROHW3", OracleType.NVarChar).Value = dwData["KAVFGKROHW3"].ToString(); 
          or1.Parameters.Add("KAVFGKROHW4", OracleType.NVarChar).Value = dwData["KAVFGKROHW4"].ToString(); 
          or1.Parameters.Add("KAVFGKROHW5", OracleType.NVarChar).Value = dwData["KAVFGKROHW5"].ToString(); 
          or1.Parameters.Add("KAVFGKV1", OracleType.NVarChar).Value = dwData["KAVFGKV1"].ToString(); 
          or1.Parameters.Add("KAVFGKV2", OracleType.NVarChar).Value = dwData["KAVFGKV2"].ToString(); 
          or1.Parameters.Add("KAVFGKV3", OracleType.NVarChar).Value = dwData["KAVFGKV3"].ToString(); 
          or1.Parameters.Add("KAVFGKV4", OracleType.NVarChar).Value = dwData["KAVFGKV4"].ToString(); 
          or1.Parameters.Add("KAVFGKV5", OracleType.NVarChar).Value = dwData["KAVFGKV5"].ToString(); 
          or1.Parameters.Add("KAVFGKKONF1", OracleType.NVarChar).Value = dwData["KAVFGKKONF1"].ToString(); 
          or1.Parameters.Add("KAVFGKKONF2", OracleType.NVarChar).Value = dwData["KAVFGKKONF2"].ToString(); 
          or1.Parameters.Add("KAVFGKKONF3", OracleType.NVarChar).Value = dwData["KAVFGKKONF3"].ToString(); 
          or1.Parameters.Add("KAVFGKKONF4", OracleType.NVarChar).Value = dwData["KAVFGKKONF4"].ToString(); 
          or1.Parameters.Add("KAVFGKKONF5", OracleType.NVarChar).Value = dwData["KAVFGKKONF5"].ToString(); 
          or1.Parameters.Add("KAVVERPI", OracleType.NVarChar).Value = dwData["KAVVERPI"].ToString(); 
          or1.Parameters.Add("KAVVERPE", OracleType.NVarChar).Value = dwData["KAVVERPE"].ToString(); 
          or1.Parameters.Add("KAVVERSI", OracleType.NVarChar).Value = dwData["KAVVERSI"].ToString(); 
          or1.Parameters.Add("KAVVERSE", OracleType.NVarChar).Value = dwData["KAVVERSE"].ToString(); 
          or1.Parameters.Add("KAVFRAI", OracleType.NVarChar).Value = dwData["KAVFRAI"].ToString(); 
          or1.Parameters.Add("KAVFRAE", OracleType.NVarChar).Value = dwData["KAVFRAE"].ToString(); 
          or1.Parameters.Add("KAVZOLLI", OracleType.NVarChar).Value = dwData["KAVZOLLI"].ToString(); 
          or1.Parameters.Add("KAVZOLLE", OracleType.NVarChar).Value = dwData["KAVZOLLE"].ToString(); 
          or1.Parameters.Add("KAVPROVI", OracleType.NVarChar).Value = dwData["KAVPROVI"].ToString(); 
          or1.Parameters.Add("KAVPROVE", OracleType.NVarChar).Value = dwData["KAVPROVE"].ToString(); 
          or1.Parameters.Add("KAVBONI", OracleType.NVarChar).Value = dwData["KAVBONI"].ToString(); 
          or1.Parameters.Add("KAVBONE", OracleType.NVarChar).Value = dwData["KAVBONE"].ToString(); 
          or1.Parameters.Add("KAVSKTI", OracleType.NVarChar).Value = dwData["KAVSKTI"].ToString(); 
          or1.Parameters.Add("KAVSKTE", OracleType.NVarChar).Value = dwData["KAVSKTE"].ToString(); 
          or1.Parameters.Add("KAVEVI", OracleType.NVarChar).Value = dwData["KAVEVI"].ToString(); 
          or1.Parameters.Add("KAVEVE", OracleType.NVarChar).Value = dwData["KAVEVE"].ToString(); 
          or1.Parameters.Add("KAVSEKSI", OracleType.NVarChar).Value = dwData["KAVSEKSI"].ToString(); 
          or1.Parameters.Add("KAVSEKSE", OracleType.NVarChar).Value = dwData["KAVSEKSE"].ToString(); 
          or1.Parameters.Add("KAVSDBI", OracleType.NVarChar).Value = dwData["KAVSDBI"].ToString(); 
          or1.Parameters.Add("KAVSDBE", OracleType.NVarChar).Value = dwData["KAVSDBE"].ToString(); 
          or1.Parameters.Add("KAVZINSI", OracleType.NVarChar).Value = dwData["KAVZINSI"].ToString(); 
          or1.Parameters.Add("KAVZINSE", OracleType.NVarChar).Value = dwData["KAVZINSE"].ToString(); 
          or1.Parameters.Add("KAVSCHK", OracleType.NVarChar).Value = dwData["KAVSCHK"].ToString(); 
          or1.Parameters.Add("KAVVERPR", OracleType.NVarChar).Value = dwData["KAVVERPR"].ToString(); 
          or1.Parameters.Add("KAVZUSCHL", OracleType.NVarChar).Value = dwData["KAVZUSCHL"].ToString(); 
          or1.Parameters.Add("KAVVERKPR", OracleType.NVarChar).Value = dwData["KAVVERKPR"].ToString(); 
          or1.Parameters.Add("KAVFILLER", OracleType.NVarChar).Value = dwData["KAVFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
